topic Re: Using expressions and conditional dimension in QlikView

Using expressions and conditional dimension

Thu, 05 Sep 2013 09:05:07 GMT

Hi all,

I am quite new to expressions but very proficient with writing SQL. I am having slight problems translating simple SQL queries to expressions in qlikview. Currently i'm trying to figure out the following. Also anyone can tell me what is the difference between "conditional dimension" & "expressions".

Assuming that from a single dimension table, I simply want to translate it to a bar chart showing these 2 below, how do I go about this, This seems very simple but I am learning this concept, thx in advance!

Query1

select count(*) from dim_time

where time_id = 0;

Query2

select count(*) from dim_time

where time_id > 0;

Dim_time table

TIME_ID

-------------

1234

Re: Using expressions and conditional dimension

Nicole-Smith — Thu, 05 Sep 2013 17:50:14 GMT

I like to think about dimensions and expressions as being the x and y axes on a bar chart. Dimensions go across the x-axis (the buckets), and expressions are the calculation of a value for how large the bar will be (how far it goes up the y-axis). You can put conditions on dimensions to display the top 10, show a total bar, etc.

To create a chart with your data is seems like you want your Dimension to be TIME_ID and your Expression to be count({<TIME_ID={0}>}TIME_ID) for Query1 and count({<TIME_ID={'>0'}>}TIME_ID) for Query 2.

Re: Using expressions and conditional dimension

Thu, 05 Sep 2013 19:09:01 GMT

Nicole's set analysis looks correct, but if you are still intimidated by set analysis you can use a simple IF, THEN, ELSE statement

Sum(if(Time_ID =0,1,0)) as ______

Sum(if(Time_ID>0,1,0)) as ______

Re: Using expressions and conditional dimension

Anonymous — Fri, 06 Sep 2013 12:34:08 GMT

The Set Analysis is fully correct. Talking about the concept of Condicional Dimension and Expressions:

Expression is what you wanna see and the dimension is by what. The condicional dimension is when you don't want your dimension be the same in a chart, for example.