topic variable inside set analysis in QlikView

variable inside set analysis

prasadcm — Thu, 03 Aug 2017 07:18:50 GMT

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'

But when i select that certain task

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‌

Re: variable inside set analysis

micheledenardi — Thu, 03 Aug 2017 07:22:36 GMT

Maybe like this,

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

Re: variable inside set analysis

arvind_patil — Thu, 03 Aug 2017 07:23:35 GMT

Hi Prasad,

Try to pick function with the help of wildmatch.

Thanks

Arvind Patil

Re: variable inside set analysis

prasadcm — Thu, 03 Aug 2017 07:27:07 GMT

Hi Michele,

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

but it doesnt work.

Regards,

Prasad

Re: variable inside set analysis

Gysbert_Wassenaar — Thu, 03 Aug 2017 07:33:10 GMT

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

Re: variable inside set analysis

prasadcm — Thu, 03 Aug 2017 11:28:41 GMT

Its not working

Re: variable inside set analysis

sunny_talwar — Thu, 03 Aug 2017 11:30:24 GMT

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

Re: variable inside set analysis

Miguel_Angel_Baeyens — Thu, 03 Aug 2017 11:48:46 GMT

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