Self Servicing Charts

[#1]

Hi,

I have attached a QVW that has a self servicing chart. Its a Straight table, on selecting a dimension it displays all the measures and selected dimension.

Please someone explain how its created. 

Thanks in advance

Keerthi

[tresB · Accepted solution]

Well,

=If( SubStringCount(Concat(_dimension, '|'), 'Sub Category'),If(SubStringCount(Concat(_dimension, '|'), 'Category')>1,1,0), SubStringCount(Concat(_dimension, '|'), 'Category'))

The section in RED - checks if the 'Sub Category' is there in selection, If TRUE, then it checks the PINK section - if 'Category' sub-string count is more than 1 (because, if you select only 'Sub Category' then it returns substring count 1 and you don't want to show 'Category' then) that means you have selected 'Category' as well as 'Sub Category'. In this case you set the condition true to display 'Category', otherwise FALSE.

The last section comes when 'Sub Category' is not selected (In ELSE part of RED section). Then it checks if only 'Category' is selected or not.

Hope this helps and makes sense.

[#3]

Thanks a lot tresesco

I tried removing concat(_dimension, '|') and used only =SubStringCount(_dimension, 'Day Name')

Its working but some problem when i select few dimensions.

May i know the reason why we need to use concat(_dimension, '|')

Sorry if its a simple question. I am new to qlikview have very less knowledge of set analysis.

[#4]

Hi Tresesco,

Thanks for the post.

I'm using personal edition, I would like to know how it is created.

Can you please post the qvw file, where personal edition users can open and view.

Thanks in Advance.

Regards,

Pavan.

[tresB]

That sort of qv can only be created by QlikTech. Download 'What's New in QlikView 11' app from Qlik Demos: See QlikView in Action | Demo.Qlik.Com