Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
prasadcm
Creator II
Creator II

variable inside set analysis

Hi All,

I have an expression like

=(if(vTaskOneDay,1, $(=vExpectedPCG)))

where in

vTaskOneDay =

=Match(

[Task Name],

'AP Explorer_SAN',

'FMG Explorer_SAN',

'Reload of Quotation Hit Rate',

'Reload of Sales Variance',

'Reload of Service lead time',

'Reference List',

'Reload of GL line items',

'SO Condition Type',

'Inventory report_SAN',

'Reload of Freight report',

'Customer Statistics Finland',

'Macgregor Migrated Project Life Explorer',

'Material Delivery Status',

'CashFlow_SAN',

'Production Order Dashboard',

'Production Order',

'Purchase Orders new Report  Reload',

'Reload Equipment Lead Time',

'Customs reporting Malaysia',

'Parts - Sales Dashboard_SAN')

when i dont make any selections i get values for  AP Explorer_SAN' has 2 which should be '1'p1.PNG

But when i select that certain task

p2.PNG

it gives right value
I tried something like

=(if($(vTaskOneDay),1, $(=vExpectedPCG))) &  =(if($(=vTaskOneDay),1, $(=vExpectedPCG)))

but then i get '- 'value

How am i supposed to solve this?

Regards,

Prasad Mayekar

gwassenaar swuehl

7 Replies
micheledenardi
Specialist II
Specialist II

Maybe like this,

=(if($(vTaskOneDay),1, $(vExpectedPCG))) &  (if($(vTaskOneDay),1, $(vExpectedPCG)))

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Prasad,

Try to pick function with the help of wildmatch.

Thanks

Arvind Patil

prasadcm
Creator II
Creator II
Author

Hi Michele,

I tried =(if($(vTaskOneDay),1, $(vExpectedPCG)))

but it doesnt work.


Regards,

Prasad

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try removing the = character at the front of the expression in the variable.


talk is cheap, supply exceeds demand
prasadcm
Creator II
Creator II
Author

Its not working

sunny_talwar

Would it be possible to share you application or a sample?

Miguel_Angel_Baeyens

You mentioned set analysis, how the complete expression looks like? Is it a Count(), a Sum(), an Aggr() ?