Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
prasadcm
Contributor 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
Valued Contributor

Re: variable inside set analysis

Maybe like this,

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

Partner
Partner

Re: variable inside set analysis

Hi Prasad,

Try to pick function with the help of wildmatch.

Thanks

Arvind Patil

prasadcm
Contributor II

Re: variable inside set analysis

Hi Michele,

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

but it doesnt work.


Regards,

Prasad

MVP & Luminary
MVP & Luminary

Re: variable inside set analysis

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


talk is cheap, supply exceeds demand
prasadcm
Contributor II

Re: variable inside set analysis

Its not working

Re: variable inside set analysis

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

Re: variable inside set analysis

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