topic Re: Create two Tables (Charts) based on Filter in QlikView

Create two Tables (Charts) based on Filter

qlikwiz123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a PivotTable that has few dimensions and expressions. I have another field 'Category' which has 'In' and 'Out' values.

I want to create two different tables for each category and only show Category as 'In' in Table 1 and 'Out' in Table 2. Whenever I use the expression =if(Category)='In',Category) or =if(Category)='Out',Category) in my Dimensions and Check 'Supress Null Values', I am able to see the tables for each but that is only showing Columns which are related to In or Out. I want all the Columns to be shown but values to be shown only for those that Satisfy Category filter.

In the below image, the Columns for In shows all because it satisfies the condition. But for Out, it only shows three columns since it only has those columns satisfying 'Category='Out'. But I want to show all columns in In and Out tables (but the cells can be empty or 'X')

Re: Create two Tables (Charts) based on Filter

dplr-rn — Fri, 12 Oct 2018 18:21:04 GMT

Difficult to say for sure without knowing your expressions

But i think you shouldnt Suppress Null Values.

Also for performance sake use set analysis

Re: Create two Tables (Charts) based on Filter

jayanttibhe — Fri, 12 Oct 2018 18:23:09 GMT

Sample QVW app please

Re: Create two Tables (Charts) based on Filter

qlikwiz123 — Fri, 12 Oct 2018 18:26:20 GMT

Hi Dilip,

My Expressions are quite simple. If(Value='Yes', '✔','X')

And I cannot use Set Analysis in this case since it's not a Sum or Count. Tried Only in Dimensions - only({<Category={'In'}>} Category) in Table 1 and only({<Category={'Out'}>} Category) in Table 2 but no help.

Re: Create two Tables (Charts) based on Filter

dplr-rn — Fri, 12 Oct 2018 18:29:43 GMT

Ah ok. Shouldnt matter in that case.Any luck with the removing the suppress?

its weird then. try and share a sample if you can