topic Re: Select Dimension by Condition in QlikView

Select Dimension by Condition

Fri, 03 Jul 2015 05:55:37 GMT

Hi,

I have a question, i have a data like this:

Name ValueUSD ValueSGD

A 1 2

B 3 4

I want to create a straight table and show the value according to my selection. I have a list box that contain USD and SGD. When I select USD so the 'ValueUSD' field will show and when i select SGD, so the 'ValueSGD' field will show. I've try using calculated dimension and use if for the condition. It works perfectly, but the problem is I have hundreds of million data, if i am using that method it will take time and the application will be run slower. Are there another method to optimize loading time ?

Really appreciate your help.

Thanks

Re: Select Dimension by Condition

vardhancse — Fri, 03 Jul 2015 05:57:53 GMT

use conditional expression for the dimension:

SubStringCount('|'&Concat([% USD],'|')&'|','|USD|')

Re: Select Dimension by Condition

settu_periasamy — Fri, 03 Jul 2015 06:15:33 GMT

Hi,

Have you tried the conditional based display like the below screen shot?

Re: Select Dimension by Condition

Fri, 03 Jul 2015 06:24:56 GMT

Any specific reason for using those as dimensions? Not a good idea to use any field having hundreds of millions of rows as dimension. Use them in the expression with appropriate aggregation as mentioned by settu_periasamy‌ . And enable always one selected value for the list box to select either USD or SGD for the above condition to work.

Regards,

KKR

Re: Select Dimension by Condition

Fri, 03 Jul 2015 06:26:05 GMT

Hi Sasi and Settu,

Thanks for your comments, do you know which method is faster to be processed in qlikview ? because i have hundreds of million data.

Thanks

Re: Select Dimension by Condition

Fri, 03 Jul 2015 06:27:20 GMT

Hi Kran,

Thanks for your suggestion, so Settu's method will be faster ? Can u give me the reason why ?

Ok then, i'll try. Thanks once again for your comment.

Re: Select Dimension by Condition

settu_periasamy — Fri, 03 Jul 2015 06:51:34 GMT

Hi indra1705

Already I tried the same method (I have also 100 millions record), it works faster.

if we use the conditional display, first it will check that(true or false), then only the expression will be evaluated.

Re: Select Dimension by Condition

Fri, 03 Jul 2015 06:54:13 GMT

I see,

Ok then, i'll try your suggestion. Thanks Settu