Varaible in measure

[Bakhtawar]

Hi all

I have field i drag that field in sheet .. and there is some charts

first i want to save save varaible of date and then drag that varaible in sheet

then in formula i want to call that varaible against each date field whatever is in the tables.. for suppoise i have date field

OS_date and there is several dates in it

in qlik sense i have formula like this

sum({<AS_Date= {'$(VDate)'}, LOB = {'Mot'}>}OS_AMOUNT)

in DAX i created same formula like this

vMotor_ROS = CALCULATE(sum(OS_excel[OS_AMOUNT]),Premium_Excel[LOB]="Mot")

now i want to call that as_Date in formula .. how i do this ?

VDate is the empty varaible which i drag in sheet.. what every the date i write this should be effect on

As_Date

how i do this

[Pragati11]

Hi @Bakhtawar ,

I am able to understand your query clearly. Can you please provide some screenshots ans sample data for what you are trying to achieve here?

Thanks,

Pragati

[Bakhtawar]

please conisder abt sample data

[sturlaws]

Hi @Bakhtawar,

I'm having trouble understanding your requirements. Could you provide some sample data, and create a mockup of the desired output?

Cheers,
Sturla