topic Re: Self Servicing Charts in QlikView

Self Servicing Charts

Thu, 07 Nov 2013 04:23:22 GMT

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

Re: Self Servicing Charts

Thu, 07 Nov 2013 04:27:45 GMT

Hi,

It is based on the Conditional check box under Expression tab of chart properties, refer to the attached screen shot.

Re: Self Servicing Charts

Thu, 07 Nov 2013 04:38:24 GMT

Thanks Gowri Shankar.

Could u please explain how that condition works

Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 04:41:03 GMT

Expressions and Dimensions both are displayed conditionally. If you select a dimension say ''Region'' from the field _dimension, then the condition :=SubStringCount(Concat(_dimension, '|'), 'Region') returns 1 (non zero) and it turns the condition TRUE for that dimension and it gets displayed. Similarly for expressions.

Re: Re: Self Servicing Charts

Thu, 07 Nov 2013 04:46:12 GMT

Thanks a lot tresesco

But in my application when i select a " Sub Category" dimension. Data can be seen for both "Category " and " Sub Category "

Is There any mistake in the condition.

Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 04:50:41 GMT

It would happen so, because 'Category' is a sub string of 'Sub Category'. Let me try a different condition and get back.

Update: By the time let me suggest you an alternative; RENAME 'Category' to '_Category' in the script and change the conditional expression accordingly.

Re: Self Servicing Charts

Thu, 07 Nov 2013 05:00:52 GMT

After changing to _category its working.

This is not happening for "Calendar Quarter" and "Calendar Year" since Calendar is common in both. This is happening only in case of "Category" and "Sub Category"

Re: Re: Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 05:16:15 GMT

Got it !

Use expression for 'Category' :

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

PFA

Re: Self Servicing Charts

Thu, 07 Nov 2013 05:22:08 GMT

Could you please explain the expression

Re: Re: Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 05:23:32 GMT

Hello Keerthi,

Among "Calendar Quarter" and "Calendar Year" , none of them is a sub-string to another. But it 'Category' IS a sb-string to 'Sub Category'. Isn't it so?

Re: Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 05:31:47 GMT

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.

Re: Self Servicing Charts

Thu, 07 Nov 2013 05:51:33 GMT

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.

Re: Self Servicing Charts

Thu, 07 Nov 2013 07:30:04 GMT

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.

Re: Self Servicing Charts

tresB — Thu, 07 Nov 2013 07:46:37 GMT

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