topic Re: Conditional usage issue in barchart in QlikView

Conditional usage issue in barchart

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

Dear all,

Need your help on the below issue,

I have to display the count of records which would match the condition =If(aa > bb, count(distinct(cc)))

I have taken dimension as cc

Please let me know where i need to use this condition under the expression tab in the bar chart ??

Whether it is right below condition checkbox or under defination ??

Re: Conditional usage issue in barchart

migueldelval — Thu, 15 Jun 2017 14:55:55 GMT

Hi Remo,

Could you explain a little bit your question?

Regards

Miguel del Valle

Re: Conditional usage issue in barchart

remo0017 — Fri, 16 Jun 2017 01:54:06 GMT

I am trying to get the count of records based on the condition ( a > b)

If ( a > b, count(distinct(c)))

C- field is something which i have been using as a dimension

Re: Conditional usage issue in barchart

devarasu07 — Fri, 16 Jun 2017 03:30:42 GMT

Hi,

is your aa, bb are measure value or dim value?

Expression:

=if( sum(Stock) > sum(OrderQty), count(DISTINCT Product_Code))

Count({<Product_Code ={"=sum(Stock)>sum(OrderQty)"}>}DISTINCT Product_Code)

Thanks,Deva

Re: Conditional usage issue in barchart

Anil_Babu_Samineni — Fri, 16 Jun 2017 04:15:41 GMT

What are aa and bb in your table?

Can you create one flag

Load aa, bb, cc, If(aa > bb, 1, 0) as Flag from table; // I assume, aa and bb has numbers not the characters

Then use dimensions and expression is Count({<Flag = {1}>} DISTINCT cc)

Re: Conditional usage issue in barchart

remo0017 — Fri, 16 Jun 2017 14:04:17 GMT

Hi Anil,

But problem here is aa is from table1 and bb is from table2, both these tables are connected through table3 by a common fields for both the tables table1, table2.

Re: Conditional usage issue in barchart

Anil_Babu_Samineni — Fri, 16 Jun 2017 14:09:24 GMT

Even thought, If those columns coming from two tables we will achieve by help of joins or Qualify statements.

Can you provide more information related data set or achieve same from your end